/*
 Navicat Premium Data Transfer

 Source Server         : mac
 Source Server Type    : MySQL
 Source Server Version : 50709
 Source Host           : localhost
 Source Database       : express

 Target Server Type    : MySQL
 Target Server Version : 50709
 File Encoding         : utf-8

 Date: 06/21/2017 09:56:20 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `hqhsc_product`
-- ----------------------------
DROP TABLE IF EXISTS `hqhsc_product`;
CREATE TABLE `hqhsc_product` (
  `id` varchar(64) NOT NULL,
  `name` varchar(200) NOT NULL,
  `code` varchar(64) DEFAULT NULL,
  `num` varchar(5) DEFAULT NULL,
  `price` varchar(10) DEFAULT NULL,
  `pic` varchar(100) DEFAULT NULL,
  `pic_thumb` varchar(100) DEFAULT NULL,
  `area_id` varchar(3) DEFAULT NULL,
  `sub_area_id` varchar(3) DEFAULT NULL,
  `classify_name` varchar(64) DEFAULT NULL,
  `brand` varchar(64) DEFAULT NULL,
  `no` varchar(4) DEFAULT NULL,
  `note` varchar(200) DEFAULT NULL,
  `create_by` varchar(64) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `del_flag` char(1) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `hqhsc_product`
-- ----------------------------
BEGIN;
INSERT INTO `hqhsc_product` VALUES ('404a7c2ed9f14e8d98b8bad7de8c9584', '改良版旗袍（同一系列', 'A-1067/1066/1068', '5', '598', '|/kaaction-platform/userfiles/1/files/test/hqhscProduct/2017/06/share.png', '', 'B', 'B1', '婚纱', '集典', '1', '', '1', '2017-06-21 09:11:57', '1', '2017-06-21 09:11:57', '', '0', '20'), ('f7c5b4b2ccfc4e50aa7d5b287abea481', '婚纱（XY1160）', 'A-2017-2018-2019-2020-2021', '5', '980', '|/kaaction-platform/userfiles/1/files/test/hqhscProduct/2017/06/share1.png', '/kaaction-platform/userfiles/1/_thumbs/files/test/hqhscProduct/2017/06/share1.png', 'B', 'B2', '婚纱', '花园店', '2', '', '1', '2017-06-21 09:52:49', '1', '2017-06-21 09:52:49', '', '0', '30');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
